Download File
AutomatR.GoogleSheets.Activities.DownloadFile
The "Download File" activity in AutomatR for Google Sheets allows the user to download a file from their instance of Google Sheets. This activity simplifies the process of retrieving spreadsheet content and saving it locally in desired file formats.
Properties
| Name | Description |
|---|---|
| Input | |
| Download As File | Specifies the type of file to save as: Excel Workbook (.xlsx) or PDF document (.pdf). String variables containing the file type. |
| Download Path | Specifies the local path where the file will be saved. Ensure that the path is correct and accessible. String variables containing the local path. |
| Miscellaneous | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Download File" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Example: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
How to Use
- Drag and drop the "Download File" activity onto the workflow.
- Configure the properties by specifying the delay, file type, and local download path.
- Execute the workflow to download the specified file from the Google Sheets instance.
Example
Consider an example where the "Download File" activity is used to download a sheet named "SalesData" from a Google spreadsheet in PDF format and save it locally:
Download File:
Display Name: "Download SalesData PDF"
Delay: 2
Download As File: "SalesData.pdf"
Download Path: "C:\Downloads\"
In this example, the activity downloads the "SalesData" sheet in PDF format and saves it as "SalesData.pdf" in the "C:\Downloads\" local path after a delay of 2 seconds.